package com.supplychainapi.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ScmTbpurchaseExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ScmTbpurchaseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFsPurchaseGUIDIsNull() {
            addCriterion("fsPurchaseGUID is null");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDIsNotNull() {
            addCriterion("fsPurchaseGUID is not null");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDEqualTo(String value) {
            addCriterion("fsPurchaseGUID =", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDNotEqualTo(String value) {
            addCriterion("fsPurchaseGUID <>", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDGreaterThan(String value) {
            addCriterion("fsPurchaseGUID >", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDGreaterThanOrEqualTo(String value) {
            addCriterion("fsPurchaseGUID >=", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDLessThan(String value) {
            addCriterion("fsPurchaseGUID <", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDLessThanOrEqualTo(String value) {
            addCriterion("fsPurchaseGUID <=", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDLike(String value) {
            addCriterion("fsPurchaseGUID like", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDNotLike(String value) {
            addCriterion("fsPurchaseGUID not like", value, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDIn(List<String> values) {
            addCriterion("fsPurchaseGUID in", values, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDNotIn(List<String> values) {
            addCriterion("fsPurchaseGUID not in", values, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDBetween(String value1, String value2) {
            addCriterion("fsPurchaseGUID between", value1, value2, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseGUIDNotBetween(String value1, String value2) {
            addCriterion("fsPurchaseGUID not between", value1, value2, "fsPurchaseGUID");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoIsNull() {
            addCriterion("fsPurchaseNo is null");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoIsNotNull() {
            addCriterion("fsPurchaseNo is not null");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoEqualTo(String value) {
            addCriterion("fsPurchaseNo =", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoNotEqualTo(String value) {
            addCriterion("fsPurchaseNo <>", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoGreaterThan(String value) {
            addCriterion("fsPurchaseNo >", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoGreaterThanOrEqualTo(String value) {
            addCriterion("fsPurchaseNo >=", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoLessThan(String value) {
            addCriterion("fsPurchaseNo <", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoLessThanOrEqualTo(String value) {
            addCriterion("fsPurchaseNo <=", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoLike(String value) {
            addCriterion("fsPurchaseNo like", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoNotLike(String value) {
            addCriterion("fsPurchaseNo not like", value, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoIn(List<String> values) {
            addCriterion("fsPurchaseNo in", values, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoNotIn(List<String> values) {
            addCriterion("fsPurchaseNo not in", values, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoBetween(String value1, String value2) {
            addCriterion("fsPurchaseNo between", value1, value2, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsPurchaseNoNotBetween(String value1, String value2) {
            addCriterion("fsPurchaseNo not between", value1, value2, "fsPurchaseNo");
            return (Criteria) this;
        }

        public Criteria andFsBillDateIsNull() {
            addCriterion("fsBillDate is null");
            return (Criteria) this;
        }

        public Criteria andFsBillDateIsNotNull() {
            addCriterion("fsBillDate is not null");
            return (Criteria) this;
        }

        public Criteria andFsBillDateEqualTo(String value) {
            addCriterion("fsBillDate =", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateNotEqualTo(String value) {
            addCriterion("fsBillDate <>", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateGreaterThan(String value) {
            addCriterion("fsBillDate >", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateGreaterThanOrEqualTo(String value) {
            addCriterion("fsBillDate >=", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateLessThan(String value) {
            addCriterion("fsBillDate <", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateLessThanOrEqualTo(String value) {
            addCriterion("fsBillDate <=", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateLike(String value) {
            addCriterion("fsBillDate like", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateNotLike(String value) {
            addCriterion("fsBillDate not like", value, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateIn(List<String> values) {
            addCriterion("fsBillDate in", values, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateNotIn(List<String> values) {
            addCriterion("fsBillDate not in", values, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateBetween(String value1, String value2) {
            addCriterion("fsBillDate between", value1, value2, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFsBillDateNotBetween(String value1, String value2) {
            addCriterion("fsBillDate not between", value1, value2, "fsBillDate");
            return (Criteria) this;
        }

        public Criteria andFiBillKindIsNull() {
            addCriterion("fiBillKind is null");
            return (Criteria) this;
        }

        public Criteria andFiBillKindIsNotNull() {
            addCriterion("fiBillKind is not null");
            return (Criteria) this;
        }

        public Criteria andFiBillKindEqualTo(Short value) {
            addCriterion("fiBillKind =", value, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindNotEqualTo(Short value) {
            addCriterion("fiBillKind <>", value, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindGreaterThan(Short value) {
            addCriterion("fiBillKind >", value, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindGreaterThanOrEqualTo(Short value) {
            addCriterion("fiBillKind >=", value, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindLessThan(Short value) {
            addCriterion("fiBillKind <", value, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindLessThanOrEqualTo(Short value) {
            addCriterion("fiBillKind <=", value, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindIn(List<Short> values) {
            addCriterion("fiBillKind in", values, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindNotIn(List<Short> values) {
            addCriterion("fiBillKind not in", values, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindBetween(Short value1, Short value2) {
            addCriterion("fiBillKind between", value1, value2, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFiBillKindNotBetween(Short value1, Short value2) {
            addCriterion("fiBillKind not between", value1, value2, "fiBillKind");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDIsNull() {
            addCriterion("fsPGUID is null");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDIsNotNull() {
            addCriterion("fsPGUID is not null");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDEqualTo(String value) {
            addCriterion("fsPGUID =", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDNotEqualTo(String value) {
            addCriterion("fsPGUID <>", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDGreaterThan(String value) {
            addCriterion("fsPGUID >", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDGreaterThanOrEqualTo(String value) {
            addCriterion("fsPGUID >=", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDLessThan(String value) {
            addCriterion("fsPGUID <", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDLessThanOrEqualTo(String value) {
            addCriterion("fsPGUID <=", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDLike(String value) {
            addCriterion("fsPGUID like", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDNotLike(String value) {
            addCriterion("fsPGUID not like", value, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDIn(List<String> values) {
            addCriterion("fsPGUID in", values, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDNotIn(List<String> values) {
            addCriterion("fsPGUID not in", values, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDBetween(String value1, String value2) {
            addCriterion("fsPGUID between", value1, value2, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsPGUIDNotBetween(String value1, String value2) {
            addCriterion("fsPGUID not between", value1, value2, "fsPGUID");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdIsNull() {
            addCriterion("fsSupplierId is null");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdIsNotNull() {
            addCriterion("fsSupplierId is not null");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdEqualTo(String value) {
            addCriterion("fsSupplierId =", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdNotEqualTo(String value) {
            addCriterion("fsSupplierId <>", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdGreaterThan(String value) {
            addCriterion("fsSupplierId >", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdGreaterThanOrEqualTo(String value) {
            addCriterion("fsSupplierId >=", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdLessThan(String value) {
            addCriterion("fsSupplierId <", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdLessThanOrEqualTo(String value) {
            addCriterion("fsSupplierId <=", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdLike(String value) {
            addCriterion("fsSupplierId like", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdNotLike(String value) {
            addCriterion("fsSupplierId not like", value, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdIn(List<String> values) {
            addCriterion("fsSupplierId in", values, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdNotIn(List<String> values) {
            addCriterion("fsSupplierId not in", values, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdBetween(String value1, String value2) {
            addCriterion("fsSupplierId between", value1, value2, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierIdNotBetween(String value1, String value2) {
            addCriterion("fsSupplierId not between", value1, value2, "fsSupplierId");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameIsNull() {
            addCriterion("fsSupplierName is null");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameIsNotNull() {
            addCriterion("fsSupplierName is not null");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameEqualTo(String value) {
            addCriterion("fsSupplierName =", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameNotEqualTo(String value) {
            addCriterion("fsSupplierName <>", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameGreaterThan(String value) {
            addCriterion("fsSupplierName >", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameGreaterThanOrEqualTo(String value) {
            addCriterion("fsSupplierName >=", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameLessThan(String value) {
            addCriterion("fsSupplierName <", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameLessThanOrEqualTo(String value) {
            addCriterion("fsSupplierName <=", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameLike(String value) {
            addCriterion("fsSupplierName like", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameNotLike(String value) {
            addCriterion("fsSupplierName not like", value, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameIn(List<String> values) {
            addCriterion("fsSupplierName in", values, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameNotIn(List<String> values) {
            addCriterion("fsSupplierName not in", values, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameBetween(String value1, String value2) {
            addCriterion("fsSupplierName between", value1, value2, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsSupplierNameNotBetween(String value1, String value2) {
            addCriterion("fsSupplierName not between", value1, value2, "fsSupplierName");
            return (Criteria) this;
        }

        public Criteria andFsContactIsNull() {
            addCriterion("fsContact is null");
            return (Criteria) this;
        }

        public Criteria andFsContactIsNotNull() {
            addCriterion("fsContact is not null");
            return (Criteria) this;
        }

        public Criteria andFsContactEqualTo(String value) {
            addCriterion("fsContact =", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactNotEqualTo(String value) {
            addCriterion("fsContact <>", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactGreaterThan(String value) {
            addCriterion("fsContact >", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactGreaterThanOrEqualTo(String value) {
            addCriterion("fsContact >=", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactLessThan(String value) {
            addCriterion("fsContact <", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactLessThanOrEqualTo(String value) {
            addCriterion("fsContact <=", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactLike(String value) {
            addCriterion("fsContact like", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactNotLike(String value) {
            addCriterion("fsContact not like", value, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactIn(List<String> values) {
            addCriterion("fsContact in", values, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactNotIn(List<String> values) {
            addCriterion("fsContact not in", values, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactBetween(String value1, String value2) {
            addCriterion("fsContact between", value1, value2, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsContactNotBetween(String value1, String value2) {
            addCriterion("fsContact not between", value1, value2, "fsContact");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtIsNull() {
            addCriterion("fsCellphoneCt is null");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtIsNotNull() {
            addCriterion("fsCellphoneCt is not null");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtEqualTo(String value) {
            addCriterion("fsCellphoneCt =", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtNotEqualTo(String value) {
            addCriterion("fsCellphoneCt <>", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtGreaterThan(String value) {
            addCriterion("fsCellphoneCt >", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtGreaterThanOrEqualTo(String value) {
            addCriterion("fsCellphoneCt >=", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtLessThan(String value) {
            addCriterion("fsCellphoneCt <", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtLessThanOrEqualTo(String value) {
            addCriterion("fsCellphoneCt <=", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtLike(String value) {
            addCriterion("fsCellphoneCt like", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtNotLike(String value) {
            addCriterion("fsCellphoneCt not like", value, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtIn(List<String> values) {
            addCriterion("fsCellphoneCt in", values, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtNotIn(List<String> values) {
            addCriterion("fsCellphoneCt not in", values, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtBetween(String value1, String value2) {
            addCriterion("fsCellphoneCt between", value1, value2, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneCtNotBetween(String value1, String value2) {
            addCriterion("fsCellphoneCt not between", value1, value2, "fsCellphoneCt");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateIsNull() {
            addCriterion("fsArrivalDate is null");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateIsNotNull() {
            addCriterion("fsArrivalDate is not null");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateEqualTo(String value) {
            addCriterion("fsArrivalDate =", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateNotEqualTo(String value) {
            addCriterion("fsArrivalDate <>", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateGreaterThan(String value) {
            addCriterion("fsArrivalDate >", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateGreaterThanOrEqualTo(String value) {
            addCriterion("fsArrivalDate >=", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateLessThan(String value) {
            addCriterion("fsArrivalDate <", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateLessThanOrEqualTo(String value) {
            addCriterion("fsArrivalDate <=", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateLike(String value) {
            addCriterion("fsArrivalDate like", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateNotLike(String value) {
            addCriterion("fsArrivalDate not like", value, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateIn(List<String> values) {
            addCriterion("fsArrivalDate in", values, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateNotIn(List<String> values) {
            addCriterion("fsArrivalDate not in", values, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateBetween(String value1, String value2) {
            addCriterion("fsArrivalDate between", value1, value2, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalDateNotBetween(String value1, String value2) {
            addCriterion("fsArrivalDate not between", value1, value2, "fsArrivalDate");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrIsNull() {
            addCriterion("fsArrivalAddr is null");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrIsNotNull() {
            addCriterion("fsArrivalAddr is not null");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrEqualTo(String value) {
            addCriterion("fsArrivalAddr =", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrNotEqualTo(String value) {
            addCriterion("fsArrivalAddr <>", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrGreaterThan(String value) {
            addCriterion("fsArrivalAddr >", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrGreaterThanOrEqualTo(String value) {
            addCriterion("fsArrivalAddr >=", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrLessThan(String value) {
            addCriterion("fsArrivalAddr <", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrLessThanOrEqualTo(String value) {
            addCriterion("fsArrivalAddr <=", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrLike(String value) {
            addCriterion("fsArrivalAddr like", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrNotLike(String value) {
            addCriterion("fsArrivalAddr not like", value, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrIn(List<String> values) {
            addCriterion("fsArrivalAddr in", values, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrNotIn(List<String> values) {
            addCriterion("fsArrivalAddr not in", values, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrBetween(String value1, String value2) {
            addCriterion("fsArrivalAddr between", value1, value2, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalAddrNotBetween(String value1, String value2) {
            addCriterion("fsArrivalAddr not between", value1, value2, "fsArrivalAddr");
            return (Criteria) this;
        }

        public Criteria andFsReceiverIsNull() {
            addCriterion("fsReceiver is null");
            return (Criteria) this;
        }

        public Criteria andFsReceiverIsNotNull() {
            addCriterion("fsReceiver is not null");
            return (Criteria) this;
        }

        public Criteria andFsReceiverEqualTo(String value) {
            addCriterion("fsReceiver =", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverNotEqualTo(String value) {
            addCriterion("fsReceiver <>", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverGreaterThan(String value) {
            addCriterion("fsReceiver >", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverGreaterThanOrEqualTo(String value) {
            addCriterion("fsReceiver >=", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverLessThan(String value) {
            addCriterion("fsReceiver <", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverLessThanOrEqualTo(String value) {
            addCriterion("fsReceiver <=", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverLike(String value) {
            addCriterion("fsReceiver like", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverNotLike(String value) {
            addCriterion("fsReceiver not like", value, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverIn(List<String> values) {
            addCriterion("fsReceiver in", values, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverNotIn(List<String> values) {
            addCriterion("fsReceiver not in", values, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverBetween(String value1, String value2) {
            addCriterion("fsReceiver between", value1, value2, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsReceiverNotBetween(String value1, String value2) {
            addCriterion("fsReceiver not between", value1, value2, "fsReceiver");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrIsNull() {
            addCriterion("fsCellphoneRr is null");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrIsNotNull() {
            addCriterion("fsCellphoneRr is not null");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrEqualTo(String value) {
            addCriterion("fsCellphoneRr =", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrNotEqualTo(String value) {
            addCriterion("fsCellphoneRr <>", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrGreaterThan(String value) {
            addCriterion("fsCellphoneRr >", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrGreaterThanOrEqualTo(String value) {
            addCriterion("fsCellphoneRr >=", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrLessThan(String value) {
            addCriterion("fsCellphoneRr <", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrLessThanOrEqualTo(String value) {
            addCriterion("fsCellphoneRr <=", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrLike(String value) {
            addCriterion("fsCellphoneRr like", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrNotLike(String value) {
            addCriterion("fsCellphoneRr not like", value, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrIn(List<String> values) {
            addCriterion("fsCellphoneRr in", values, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrNotIn(List<String> values) {
            addCriterion("fsCellphoneRr not in", values, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrBetween(String value1, String value2) {
            addCriterion("fsCellphoneRr between", value1, value2, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsCellphoneRrNotBetween(String value1, String value2) {
            addCriterion("fsCellphoneRr not between", value1, value2, "fsCellphoneRr");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderIsNull() {
            addCriterion("fsArrivalReminder is null");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderIsNotNull() {
            addCriterion("fsArrivalReminder is not null");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderEqualTo(Short value) {
            addCriterion("fsArrivalReminder =", value, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderNotEqualTo(Short value) {
            addCriterion("fsArrivalReminder <>", value, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderGreaterThan(Short value) {
            addCriterion("fsArrivalReminder >", value, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderGreaterThanOrEqualTo(Short value) {
            addCriterion("fsArrivalReminder >=", value, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderLessThan(Short value) {
            addCriterion("fsArrivalReminder <", value, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderLessThanOrEqualTo(Short value) {
            addCriterion("fsArrivalReminder <=", value, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderIn(List<Short> values) {
            addCriterion("fsArrivalReminder in", values, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderNotIn(List<Short> values) {
            addCriterion("fsArrivalReminder not in", values, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderBetween(Short value1, Short value2) {
            addCriterion("fsArrivalReminder between", value1, value2, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsArrivalReminderNotBetween(Short value1, Short value2) {
            addCriterion("fsArrivalReminder not between", value1, value2, "fsArrivalReminder");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdIsNull() {
            addCriterion("fsDepartmentId is null");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdIsNotNull() {
            addCriterion("fsDepartmentId is not null");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdEqualTo(String value) {
            addCriterion("fsDepartmentId =", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdNotEqualTo(String value) {
            addCriterion("fsDepartmentId <>", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdGreaterThan(String value) {
            addCriterion("fsDepartmentId >", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdGreaterThanOrEqualTo(String value) {
            addCriterion("fsDepartmentId >=", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdLessThan(String value) {
            addCriterion("fsDepartmentId <", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdLessThanOrEqualTo(String value) {
            addCriterion("fsDepartmentId <=", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdLike(String value) {
            addCriterion("fsDepartmentId like", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdNotLike(String value) {
            addCriterion("fsDepartmentId not like", value, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdIn(List<String> values) {
            addCriterion("fsDepartmentId in", values, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdNotIn(List<String> values) {
            addCriterion("fsDepartmentId not in", values, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdBetween(String value1, String value2) {
            addCriterion("fsDepartmentId between", value1, value2, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsDepartmentIdNotBetween(String value1, String value2) {
            addCriterion("fsDepartmentId not between", value1, value2, "fsDepartmentId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdIsNull() {
            addCriterion("fsStaffId is null");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdIsNotNull() {
            addCriterion("fsStaffId is not null");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdEqualTo(String value) {
            addCriterion("fsStaffId =", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdNotEqualTo(String value) {
            addCriterion("fsStaffId <>", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdGreaterThan(String value) {
            addCriterion("fsStaffId >", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdGreaterThanOrEqualTo(String value) {
            addCriterion("fsStaffId >=", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdLessThan(String value) {
            addCriterion("fsStaffId <", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdLessThanOrEqualTo(String value) {
            addCriterion("fsStaffId <=", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdLike(String value) {
            addCriterion("fsStaffId like", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdNotLike(String value) {
            addCriterion("fsStaffId not like", value, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdIn(List<String> values) {
            addCriterion("fsStaffId in", values, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdNotIn(List<String> values) {
            addCriterion("fsStaffId not in", values, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdBetween(String value1, String value2) {
            addCriterion("fsStaffId between", value1, value2, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFsStaffIdNotBetween(String value1, String value2) {
            addCriterion("fsStaffId not between", value1, value2, "fsStaffId");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtIsNull() {
            addCriterion("fdDiscountAmt is null");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtIsNotNull() {
            addCriterion("fdDiscountAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtEqualTo(BigDecimal value) {
            addCriterion("fdDiscountAmt =", value, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtNotEqualTo(BigDecimal value) {
            addCriterion("fdDiscountAmt <>", value, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtGreaterThan(BigDecimal value) {
            addCriterion("fdDiscountAmt >", value, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdDiscountAmt >=", value, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtLessThan(BigDecimal value) {
            addCriterion("fdDiscountAmt <", value, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdDiscountAmt <=", value, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtIn(List<BigDecimal> values) {
            addCriterion("fdDiscountAmt in", values, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtNotIn(List<BigDecimal> values) {
            addCriterion("fdDiscountAmt not in", values, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdDiscountAmt between", value1, value2, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdDiscountAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdDiscountAmt not between", value1, value2, "fdDiscountAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtIsNull() {
            addCriterion("fdPurchaseMoneyAmt is null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtIsNotNull() {
            addCriterion("fdPurchaseMoneyAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseMoneyAmt =", value, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtNotEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseMoneyAmt <>", value, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtGreaterThan(BigDecimal value) {
            addCriterion("fdPurchaseMoneyAmt >", value, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseMoneyAmt >=", value, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtLessThan(BigDecimal value) {
            addCriterion("fdPurchaseMoneyAmt <", value, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseMoneyAmt <=", value, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseMoneyAmt in", values, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtNotIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseMoneyAmt not in", values, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseMoneyAmt between", value1, value2, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseMoneyAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseMoneyAmt not between", value1, value2, "fdPurchaseMoneyAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtIsNull() {
            addCriterion("fdPurchaseTaxAmt is null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtIsNotNull() {
            addCriterion("fdPurchaseTaxAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTaxAmt =", value, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtNotEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTaxAmt <>", value, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtGreaterThan(BigDecimal value) {
            addCriterion("fdPurchaseTaxAmt >", value, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTaxAmt >=", value, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtLessThan(BigDecimal value) {
            addCriterion("fdPurchaseTaxAmt <", value, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTaxAmt <=", value, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseTaxAmt in", values, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtNotIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseTaxAmt not in", values, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseTaxAmt between", value1, value2, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTaxAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseTaxAmt not between", value1, value2, "fdPurchaseTaxAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtIsNull() {
            addCriterion("fdPurchaseTotAmt is null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtIsNotNull() {
            addCriterion("fdPurchaseTotAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTotAmt =", value, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtNotEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTotAmt <>", value, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtGreaterThan(BigDecimal value) {
            addCriterion("fdPurchaseTotAmt >", value, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTotAmt >=", value, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtLessThan(BigDecimal value) {
            addCriterion("fdPurchaseTotAmt <", value, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseTotAmt <=", value, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseTotAmt in", values, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtNotIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseTotAmt not in", values, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseTotAmt between", value1, value2, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseTotAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseTotAmt not between", value1, value2, "fdPurchaseTotAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateIsNull() {
            addCriterion("fdBenefitRate is null");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateIsNotNull() {
            addCriterion("fdBenefitRate is not null");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateEqualTo(BigDecimal value) {
            addCriterion("fdBenefitRate =", value, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateNotEqualTo(BigDecimal value) {
            addCriterion("fdBenefitRate <>", value, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateGreaterThan(BigDecimal value) {
            addCriterion("fdBenefitRate >", value, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdBenefitRate >=", value, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateLessThan(BigDecimal value) {
            addCriterion("fdBenefitRate <", value, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdBenefitRate <=", value, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateIn(List<BigDecimal> values) {
            addCriterion("fdBenefitRate in", values, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateNotIn(List<BigDecimal> values) {
            addCriterion("fdBenefitRate not in", values, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdBenefitRate between", value1, value2, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdBenefitRate not between", value1, value2, "fdBenefitRate");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtIsNull() {
            addCriterion("fdBenefitAmt is null");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtIsNotNull() {
            addCriterion("fdBenefitAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtEqualTo(BigDecimal value) {
            addCriterion("fdBenefitAmt =", value, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtNotEqualTo(BigDecimal value) {
            addCriterion("fdBenefitAmt <>", value, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtGreaterThan(BigDecimal value) {
            addCriterion("fdBenefitAmt >", value, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdBenefitAmt >=", value, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtLessThan(BigDecimal value) {
            addCriterion("fdBenefitAmt <", value, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdBenefitAmt <=", value, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtIn(List<BigDecimal> values) {
            addCriterion("fdBenefitAmt in", values, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtNotIn(List<BigDecimal> values) {
            addCriterion("fdBenefitAmt not in", values, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdBenefitAmt between", value1, value2, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdBenefitAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdBenefitAmt not between", value1, value2, "fdBenefitAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtIsNull() {
            addCriterion("fdPurchaseAmt is null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtIsNotNull() {
            addCriterion("fdPurchaseAmt is not null");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseAmt =", value, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtNotEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseAmt <>", value, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtGreaterThan(BigDecimal value) {
            addCriterion("fdPurchaseAmt >", value, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseAmt >=", value, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtLessThan(BigDecimal value) {
            addCriterion("fdPurchaseAmt <", value, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fdPurchaseAmt <=", value, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseAmt in", values, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtNotIn(List<BigDecimal> values) {
            addCriterion("fdPurchaseAmt not in", values, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseAmt between", value1, value2, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFdPurchaseAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fdPurchaseAmt not between", value1, value2, "fdPurchaseAmt");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusIsNull() {
            addCriterion("fiBillStatus is null");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusIsNotNull() {
            addCriterion("fiBillStatus is not null");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusEqualTo(Short value) {
            addCriterion("fiBillStatus =", value, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusNotEqualTo(Short value) {
            addCriterion("fiBillStatus <>", value, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusGreaterThan(Short value) {
            addCriterion("fiBillStatus >", value, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("fiBillStatus >=", value, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusLessThan(Short value) {
            addCriterion("fiBillStatus <", value, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusLessThanOrEqualTo(Short value) {
            addCriterion("fiBillStatus <=", value, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusIn(List<Short> values) {
            addCriterion("fiBillStatus in", values, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusNotIn(List<Short> values) {
            addCriterion("fiBillStatus not in", values, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusBetween(Short value1, Short value2) {
            addCriterion("fiBillStatus between", value1, value2, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFiBillStatusNotBetween(Short value1, Short value2) {
            addCriterion("fiBillStatus not between", value1, value2, "fiBillStatus");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdIsNull() {
            addCriterion("fsAuditUserId is null");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdIsNotNull() {
            addCriterion("fsAuditUserId is not null");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdEqualTo(String value) {
            addCriterion("fsAuditUserId =", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdNotEqualTo(String value) {
            addCriterion("fsAuditUserId <>", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdGreaterThan(String value) {
            addCriterion("fsAuditUserId >", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("fsAuditUserId >=", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdLessThan(String value) {
            addCriterion("fsAuditUserId <", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdLessThanOrEqualTo(String value) {
            addCriterion("fsAuditUserId <=", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdLike(String value) {
            addCriterion("fsAuditUserId like", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdNotLike(String value) {
            addCriterion("fsAuditUserId not like", value, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdIn(List<String> values) {
            addCriterion("fsAuditUserId in", values, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdNotIn(List<String> values) {
            addCriterion("fsAuditUserId not in", values, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdBetween(String value1, String value2) {
            addCriterion("fsAuditUserId between", value1, value2, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserIdNotBetween(String value1, String value2) {
            addCriterion("fsAuditUserId not between", value1, value2, "fsAuditUserId");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameIsNull() {
            addCriterion("fsAuditUserName is null");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameIsNotNull() {
            addCriterion("fsAuditUserName is not null");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameEqualTo(String value) {
            addCriterion("fsAuditUserName =", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameNotEqualTo(String value) {
            addCriterion("fsAuditUserName <>", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameGreaterThan(String value) {
            addCriterion("fsAuditUserName >", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("fsAuditUserName >=", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameLessThan(String value) {
            addCriterion("fsAuditUserName <", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameLessThanOrEqualTo(String value) {
            addCriterion("fsAuditUserName <=", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameLike(String value) {
            addCriterion("fsAuditUserName like", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameNotLike(String value) {
            addCriterion("fsAuditUserName not like", value, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameIn(List<String> values) {
            addCriterion("fsAuditUserName in", values, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameNotIn(List<String> values) {
            addCriterion("fsAuditUserName not in", values, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameBetween(String value1, String value2) {
            addCriterion("fsAuditUserName between", value1, value2, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditUserNameNotBetween(String value1, String value2) {
            addCriterion("fsAuditUserName not between", value1, value2, "fsAuditUserName");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeIsNull() {
            addCriterion("fsAuditDateTime is null");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeIsNotNull() {
            addCriterion("fsAuditDateTime is not null");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeEqualTo(String value) {
            addCriterion("fsAuditDateTime =", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeNotEqualTo(String value) {
            addCriterion("fsAuditDateTime <>", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeGreaterThan(String value) {
            addCriterion("fsAuditDateTime >", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("fsAuditDateTime >=", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeLessThan(String value) {
            addCriterion("fsAuditDateTime <", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeLessThanOrEqualTo(String value) {
            addCriterion("fsAuditDateTime <=", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeLike(String value) {
            addCriterion("fsAuditDateTime like", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeNotLike(String value) {
            addCriterion("fsAuditDateTime not like", value, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeIn(List<String> values) {
            addCriterion("fsAuditDateTime in", values, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeNotIn(List<String> values) {
            addCriterion("fsAuditDateTime not in", values, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeBetween(String value1, String value2) {
            addCriterion("fsAuditDateTime between", value1, value2, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsAuditDateTimeNotBetween(String value1, String value2) {
            addCriterion("fsAuditDateTime not between", value1, value2, "fsAuditDateTime");
            return (Criteria) this;
        }

        public Criteria andFsNoteIsNull() {
            addCriterion("fsNote is null");
            return (Criteria) this;
        }

        public Criteria andFsNoteIsNotNull() {
            addCriterion("fsNote is not null");
            return (Criteria) this;
        }

        public Criteria andFsNoteEqualTo(String value) {
            addCriterion("fsNote =", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteNotEqualTo(String value) {
            addCriterion("fsNote <>", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteGreaterThan(String value) {
            addCriterion("fsNote >", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteGreaterThanOrEqualTo(String value) {
            addCriterion("fsNote >=", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteLessThan(String value) {
            addCriterion("fsNote <", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteLessThanOrEqualTo(String value) {
            addCriterion("fsNote <=", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteLike(String value) {
            addCriterion("fsNote like", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteNotLike(String value) {
            addCriterion("fsNote not like", value, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteIn(List<String> values) {
            addCriterion("fsNote in", values, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteNotIn(List<String> values) {
            addCriterion("fsNote not in", values, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteBetween(String value1, String value2) {
            addCriterion("fsNote between", value1, value2, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsNoteNotBetween(String value1, String value2) {
            addCriterion("fsNote not between", value1, value2, "fsNote");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceIsNull() {
            addCriterion("fsBillSource is null");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceIsNotNull() {
            addCriterion("fsBillSource is not null");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceEqualTo(String value) {
            addCriterion("fsBillSource =", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceNotEqualTo(String value) {
            addCriterion("fsBillSource <>", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceGreaterThan(String value) {
            addCriterion("fsBillSource >", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceGreaterThanOrEqualTo(String value) {
            addCriterion("fsBillSource >=", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceLessThan(String value) {
            addCriterion("fsBillSource <", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceLessThanOrEqualTo(String value) {
            addCriterion("fsBillSource <=", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceLike(String value) {
            addCriterion("fsBillSource like", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceNotLike(String value) {
            addCriterion("fsBillSource not like", value, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceIn(List<String> values) {
            addCriterion("fsBillSource in", values, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceNotIn(List<String> values) {
            addCriterion("fsBillSource not in", values, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceBetween(String value1, String value2) {
            addCriterion("fsBillSource between", value1, value2, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFsBillSourceNotBetween(String value1, String value2) {
            addCriterion("fsBillSource not between", value1, value2, "fsBillSource");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditIsNull() {
            addCriterion("fiVendorEdit is null");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditIsNotNull() {
            addCriterion("fiVendorEdit is not null");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditEqualTo(Short value) {
            addCriterion("fiVendorEdit =", value, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditNotEqualTo(Short value) {
            addCriterion("fiVendorEdit <>", value, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditGreaterThan(Short value) {
            addCriterion("fiVendorEdit >", value, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditGreaterThanOrEqualTo(Short value) {
            addCriterion("fiVendorEdit >=", value, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditLessThan(Short value) {
            addCriterion("fiVendorEdit <", value, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditLessThanOrEqualTo(Short value) {
            addCriterion("fiVendorEdit <=", value, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditIn(List<Short> values) {
            addCriterion("fiVendorEdit in", values, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditNotIn(List<Short> values) {
            addCriterion("fiVendorEdit not in", values, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditBetween(Short value1, Short value2) {
            addCriterion("fiVendorEdit between", value1, value2, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFiVendorEditNotBetween(Short value1, Short value2) {
            addCriterion("fiVendorEdit not between", value1, value2, "fiVendorEdit");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateIsNull() {
            addCriterion("fsSettleDate is null");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateIsNotNull() {
            addCriterion("fsSettleDate is not null");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateEqualTo(String value) {
            addCriterion("fsSettleDate =", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateNotEqualTo(String value) {
            addCriterion("fsSettleDate <>", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateGreaterThan(String value) {
            addCriterion("fsSettleDate >", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateGreaterThanOrEqualTo(String value) {
            addCriterion("fsSettleDate >=", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateLessThan(String value) {
            addCriterion("fsSettleDate <", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateLessThanOrEqualTo(String value) {
            addCriterion("fsSettleDate <=", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateLike(String value) {
            addCriterion("fsSettleDate like", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateNotLike(String value) {
            addCriterion("fsSettleDate not like", value, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateIn(List<String> values) {
            addCriterion("fsSettleDate in", values, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateNotIn(List<String> values) {
            addCriterion("fsSettleDate not in", values, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateBetween(String value1, String value2) {
            addCriterion("fsSettleDate between", value1, value2, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFsSettleDateNotBetween(String value1, String value2) {
            addCriterion("fsSettleDate not between", value1, value2, "fsSettleDate");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagIsNull() {
            addCriterion("fiPaymentFlag is null");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagIsNotNull() {
            addCriterion("fiPaymentFlag is not null");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagEqualTo(Short value) {
            addCriterion("fiPaymentFlag =", value, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagNotEqualTo(Short value) {
            addCriterion("fiPaymentFlag <>", value, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagGreaterThan(Short value) {
            addCriterion("fiPaymentFlag >", value, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("fiPaymentFlag >=", value, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagLessThan(Short value) {
            addCriterion("fiPaymentFlag <", value, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagLessThanOrEqualTo(Short value) {
            addCriterion("fiPaymentFlag <=", value, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagIn(List<Short> values) {
            addCriterion("fiPaymentFlag in", values, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagNotIn(List<Short> values) {
            addCriterion("fiPaymentFlag not in", values, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagBetween(Short value1, Short value2) {
            addCriterion("fiPaymentFlag between", value1, value2, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiPaymentFlagNotBetween(Short value1, Short value2) {
            addCriterion("fiPaymentFlag not between", value1, value2, "fiPaymentFlag");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseIsNull() {
            addCriterion("fiSaleClose is null");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseIsNotNull() {
            addCriterion("fiSaleClose is not null");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseEqualTo(Short value) {
            addCriterion("fiSaleClose =", value, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseNotEqualTo(Short value) {
            addCriterion("fiSaleClose <>", value, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseGreaterThan(Short value) {
            addCriterion("fiSaleClose >", value, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseGreaterThanOrEqualTo(Short value) {
            addCriterion("fiSaleClose >=", value, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseLessThan(Short value) {
            addCriterion("fiSaleClose <", value, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseLessThanOrEqualTo(Short value) {
            addCriterion("fiSaleClose <=", value, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseIn(List<Short> values) {
            addCriterion("fiSaleClose in", values, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseNotIn(List<Short> values) {
            addCriterion("fiSaleClose not in", values, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseBetween(Short value1, Short value2) {
            addCriterion("fiSaleClose between", value1, value2, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiSaleCloseNotBetween(Short value1, Short value2) {
            addCriterion("fiSaleClose not between", value1, value2, "fiSaleClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseIsNull() {
            addCriterion("fiStockClose is null");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseIsNotNull() {
            addCriterion("fiStockClose is not null");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseEqualTo(Short value) {
            addCriterion("fiStockClose =", value, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseNotEqualTo(Short value) {
            addCriterion("fiStockClose <>", value, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseGreaterThan(Short value) {
            addCriterion("fiStockClose >", value, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseGreaterThanOrEqualTo(Short value) {
            addCriterion("fiStockClose >=", value, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseLessThan(Short value) {
            addCriterion("fiStockClose <", value, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseLessThanOrEqualTo(Short value) {
            addCriterion("fiStockClose <=", value, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseIn(List<Short> values) {
            addCriterion("fiStockClose in", values, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseNotIn(List<Short> values) {
            addCriterion("fiStockClose not in", values, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseBetween(Short value1, Short value2) {
            addCriterion("fiStockClose between", value1, value2, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFiStockCloseNotBetween(Short value1, Short value2) {
            addCriterion("fiStockClose not between", value1, value2, "fiStockClose");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDIsNull() {
            addCriterion("fsStockGUID is null");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDIsNotNull() {
            addCriterion("fsStockGUID is not null");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDEqualTo(String value) {
            addCriterion("fsStockGUID =", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDNotEqualTo(String value) {
            addCriterion("fsStockGUID <>", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDGreaterThan(String value) {
            addCriterion("fsStockGUID >", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDGreaterThanOrEqualTo(String value) {
            addCriterion("fsStockGUID >=", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDLessThan(String value) {
            addCriterion("fsStockGUID <", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDLessThanOrEqualTo(String value) {
            addCriterion("fsStockGUID <=", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDLike(String value) {
            addCriterion("fsStockGUID like", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDNotLike(String value) {
            addCriterion("fsStockGUID not like", value, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDIn(List<String> values) {
            addCriterion("fsStockGUID in", values, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDNotIn(List<String> values) {
            addCriterion("fsStockGUID not in", values, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDBetween(String value1, String value2) {
            addCriterion("fsStockGUID between", value1, value2, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockGUIDNotBetween(String value1, String value2) {
            addCriterion("fsStockGUID not between", value1, value2, "fsStockGUID");
            return (Criteria) this;
        }

        public Criteria andFsStockNoIsNull() {
            addCriterion("fsStockNo is null");
            return (Criteria) this;
        }

        public Criteria andFsStockNoIsNotNull() {
            addCriterion("fsStockNo is not null");
            return (Criteria) this;
        }

        public Criteria andFsStockNoEqualTo(String value) {
            addCriterion("fsStockNo =", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoNotEqualTo(String value) {
            addCriterion("fsStockNo <>", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoGreaterThan(String value) {
            addCriterion("fsStockNo >", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoGreaterThanOrEqualTo(String value) {
            addCriterion("fsStockNo >=", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoLessThan(String value) {
            addCriterion("fsStockNo <", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoLessThanOrEqualTo(String value) {
            addCriterion("fsStockNo <=", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoLike(String value) {
            addCriterion("fsStockNo like", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoNotLike(String value) {
            addCriterion("fsStockNo not like", value, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoIn(List<String> values) {
            addCriterion("fsStockNo in", values, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoNotIn(List<String> values) {
            addCriterion("fsStockNo not in", values, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoBetween(String value1, String value2) {
            addCriterion("fsStockNo between", value1, value2, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsStockNoNotBetween(String value1, String value2) {
            addCriterion("fsStockNo not between", value1, value2, "fsStockNo");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeIsNull() {
            addCriterion("fsCreateTime is null");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeIsNotNull() {
            addCriterion("fsCreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeEqualTo(Date value) {
            addCriterion("fsCreateTime =", value, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeNotEqualTo(Date value) {
            addCriterion("fsCreateTime <>", value, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeGreaterThan(Date value) {
            addCriterion("fsCreateTime >", value, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("fsCreateTime >=", value, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeLessThan(Date value) {
            addCriterion("fsCreateTime <", value, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("fsCreateTime <=", value, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeIn(List<Date> values) {
            addCriterion("fsCreateTime in", values, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeNotIn(List<Date> values) {
            addCriterion("fsCreateTime not in", values, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeBetween(Date value1, Date value2) {
            addCriterion("fsCreateTime between", value1, value2, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("fsCreateTime not between", value1, value2, "fsCreateTime");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdIsNull() {
            addCriterion("fsCreateUserId is null");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdIsNotNull() {
            addCriterion("fsCreateUserId is not null");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdEqualTo(String value) {
            addCriterion("fsCreateUserId =", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdNotEqualTo(String value) {
            addCriterion("fsCreateUserId <>", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdGreaterThan(String value) {
            addCriterion("fsCreateUserId >", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("fsCreateUserId >=", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdLessThan(String value) {
            addCriterion("fsCreateUserId <", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdLessThanOrEqualTo(String value) {
            addCriterion("fsCreateUserId <=", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdLike(String value) {
            addCriterion("fsCreateUserId like", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdNotLike(String value) {
            addCriterion("fsCreateUserId not like", value, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdIn(List<String> values) {
            addCriterion("fsCreateUserId in", values, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdNotIn(List<String> values) {
            addCriterion("fsCreateUserId not in", values, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdBetween(String value1, String value2) {
            addCriterion("fsCreateUserId between", value1, value2, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserIdNotBetween(String value1, String value2) {
            addCriterion("fsCreateUserId not between", value1, value2, "fsCreateUserId");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameIsNull() {
            addCriterion("fsCreateUserName is null");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameIsNotNull() {
            addCriterion("fsCreateUserName is not null");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameEqualTo(String value) {
            addCriterion("fsCreateUserName =", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameNotEqualTo(String value) {
            addCriterion("fsCreateUserName <>", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameGreaterThan(String value) {
            addCriterion("fsCreateUserName >", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("fsCreateUserName >=", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameLessThan(String value) {
            addCriterion("fsCreateUserName <", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameLessThanOrEqualTo(String value) {
            addCriterion("fsCreateUserName <=", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameLike(String value) {
            addCriterion("fsCreateUserName like", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameNotLike(String value) {
            addCriterion("fsCreateUserName not like", value, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameIn(List<String> values) {
            addCriterion("fsCreateUserName in", values, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameNotIn(List<String> values) {
            addCriterion("fsCreateUserName not in", values, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameBetween(String value1, String value2) {
            addCriterion("fsCreateUserName between", value1, value2, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsCreateUserNameNotBetween(String value1, String value2) {
            addCriterion("fsCreateUserName not between", value1, value2, "fsCreateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeIsNull() {
            addCriterion("fsUpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeIsNotNull() {
            addCriterion("fsUpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeEqualTo(Date value) {
            addCriterion("fsUpdateTime =", value, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeNotEqualTo(Date value) {
            addCriterion("fsUpdateTime <>", value, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeGreaterThan(Date value) {
            addCriterion("fsUpdateTime >", value, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("fsUpdateTime >=", value, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeLessThan(Date value) {
            addCriterion("fsUpdateTime <", value, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("fsUpdateTime <=", value, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeIn(List<Date> values) {
            addCriterion("fsUpdateTime in", values, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeNotIn(List<Date> values) {
            addCriterion("fsUpdateTime not in", values, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("fsUpdateTime between", value1, value2, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("fsUpdateTime not between", value1, value2, "fsUpdateTime");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdIsNull() {
            addCriterion("fsUpdateUserId is null");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdIsNotNull() {
            addCriterion("fsUpdateUserId is not null");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdEqualTo(String value) {
            addCriterion("fsUpdateUserId =", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdNotEqualTo(String value) {
            addCriterion("fsUpdateUserId <>", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdGreaterThan(String value) {
            addCriterion("fsUpdateUserId >", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("fsUpdateUserId >=", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdLessThan(String value) {
            addCriterion("fsUpdateUserId <", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdLessThanOrEqualTo(String value) {
            addCriterion("fsUpdateUserId <=", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdLike(String value) {
            addCriterion("fsUpdateUserId like", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdNotLike(String value) {
            addCriterion("fsUpdateUserId not like", value, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdIn(List<String> values) {
            addCriterion("fsUpdateUserId in", values, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdNotIn(List<String> values) {
            addCriterion("fsUpdateUserId not in", values, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdBetween(String value1, String value2) {
            addCriterion("fsUpdateUserId between", value1, value2, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserIdNotBetween(String value1, String value2) {
            addCriterion("fsUpdateUserId not between", value1, value2, "fsUpdateUserId");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameIsNull() {
            addCriterion("fsUpdateUserName is null");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameIsNotNull() {
            addCriterion("fsUpdateUserName is not null");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameEqualTo(String value) {
            addCriterion("fsUpdateUserName =", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameNotEqualTo(String value) {
            addCriterion("fsUpdateUserName <>", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameGreaterThan(String value) {
            addCriterion("fsUpdateUserName >", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("fsUpdateUserName >=", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameLessThan(String value) {
            addCriterion("fsUpdateUserName <", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameLessThanOrEqualTo(String value) {
            addCriterion("fsUpdateUserName <=", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameLike(String value) {
            addCriterion("fsUpdateUserName like", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameNotLike(String value) {
            addCriterion("fsUpdateUserName not like", value, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameIn(List<String> values) {
            addCriterion("fsUpdateUserName in", values, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameNotIn(List<String> values) {
            addCriterion("fsUpdateUserName not in", values, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameBetween(String value1, String value2) {
            addCriterion("fsUpdateUserName between", value1, value2, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsUpdateUserNameNotBetween(String value1, String value2) {
            addCriterion("fsUpdateUserName not between", value1, value2, "fsUpdateUserName");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDIsNull() {
            addCriterion("fsShopGUID is null");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDIsNotNull() {
            addCriterion("fsShopGUID is not null");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDEqualTo(String value) {
            addCriterion("fsShopGUID =", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDNotEqualTo(String value) {
            addCriterion("fsShopGUID <>", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDGreaterThan(String value) {
            addCriterion("fsShopGUID >", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDGreaterThanOrEqualTo(String value) {
            addCriterion("fsShopGUID >=", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDLessThan(String value) {
            addCriterion("fsShopGUID <", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDLessThanOrEqualTo(String value) {
            addCriterion("fsShopGUID <=", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDLike(String value) {
            addCriterion("fsShopGUID like", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDNotLike(String value) {
            addCriterion("fsShopGUID not like", value, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDIn(List<String> values) {
            addCriterion("fsShopGUID in", values, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDNotIn(List<String> values) {
            addCriterion("fsShopGUID not in", values, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDBetween(String value1, String value2) {
            addCriterion("fsShopGUID between", value1, value2, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopGUIDNotBetween(String value1, String value2) {
            addCriterion("fsShopGUID not between", value1, value2, "fsShopGUID");
            return (Criteria) this;
        }

        public Criteria andFsShopNameIsNull() {
            addCriterion("fsShopName is null");
            return (Criteria) this;
        }

        public Criteria andFsShopNameIsNotNull() {
            addCriterion("fsShopName is not null");
            return (Criteria) this;
        }

        public Criteria andFsShopNameEqualTo(String value) {
            addCriterion("fsShopName =", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameNotEqualTo(String value) {
            addCriterion("fsShopName <>", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameGreaterThan(String value) {
            addCriterion("fsShopName >", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("fsShopName >=", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameLessThan(String value) {
            addCriterion("fsShopName <", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameLessThanOrEqualTo(String value) {
            addCriterion("fsShopName <=", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameLike(String value) {
            addCriterion("fsShopName like", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameNotLike(String value) {
            addCriterion("fsShopName not like", value, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameIn(List<String> values) {
            addCriterion("fsShopName in", values, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameNotIn(List<String> values) {
            addCriterion("fsShopName not in", values, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameBetween(String value1, String value2) {
            addCriterion("fsShopName between", value1, value2, "fsShopName");
            return (Criteria) this;
        }

        public Criteria andFsShopNameNotBetween(String value1, String value2) {
            addCriterion("fsShopName not between", value1, value2, "fsShopName");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}